﻿CREATE TABLE [dbo].[OrderRequestItem] (
    [Id]                 UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [OrderRequestId]     UNIQUEIDENTIFIER NOT NULL,
    [ItemId]             UNIQUEIDENTIFIER NOT NULL,
    [ItemDescription]    NTEXT            NOT NULL,
    [UnitOfMeasure]      UNIQUEIDENTIFIER NOT NULL,
    [Quantity]           DECIMAL (18)     NOT NULL,
    [EstimatedUnitPrice] MONEY            NOT NULL,
    [EstimatedPrice]     MONEY            NOT NULL,
    [BudgetLineId]       UNIQUEIDENTIFIER NOT NULL,
    [Remarks]            NTEXT            NULL,
    [ProjectDonorId]     UNIQUEIDENTIFIER NOT NULL
);

